Review: Relationships & Joins

Resources on SQL Joins

What is the difference between an inner join and an outer join?

An INNER join selects all rows from both tables that have matching primary and foreign keys

An OUTER join selects all rows from both tables that have matching primary and foreign keys

An INNER join selects all rows from both tables that have a match between the columns

An OUTER join selects all rows from both tables that have a match between the columns

SOLUTION:

An INNER join selects all rows from both tables that have a match between the columns

SOLUTION:

INNER JOIN

QUIZ QUESTION: :

Here's the SQL join example shown in the above video:

SELECT make, model, year FROM vehicles
    JOIN drivers
    ON vehicles.driver_id = drivers.id
    WHERE drivers.name = 'Sarah';

See if you can label the following parts of the statement:

ANSWER CHOICES:

SOLUTION: